package com.siwei.mes.mapper.experiment;


import com.siwei.mes.common.base.BaseMapper;
import com.siwei.mes.entity.experiment.OpenAppraisal;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 开盘鉴定表(OpenAppraisal)表数据库访问层
 *
 * @author yangke
 * @since 2024-11-23 10:50:06
 */
public interface OpenAppraisalMapper extends BaseMapper<OpenAppraisal> {
    /**
     * 获取所有
     *
     * @param entity
     * @return
     */
    List<OpenAppraisal> getList(OpenAppraisal entity);

    /**
     * 根据id获取
     *
     * @param id
     * @return
     */
    OpenAppraisal loadById(@Param("id") Long id);

    /**
     * 根据任务单id获取
     *
     * @param frwdh
     * @return
     */
    OpenAppraisal loadByFrwdh(@Param("frwdh") Integer frwdh);

    /**
     * 根据年份、配合比编号查询是否有符合条件的开盘鉴定
     *
     * @param year
     * @param proportionPhb
     * @return
     */
    OpenAppraisal selectByItemOrder(@Param("year") String year,@Param("projectName") String projectName,@Param("proportionPhb") String proportionPhb);

}
